Performance Guidelines for Dining Table List

In this article

Required Field 

Optional Fields

In the dining table list layout, managed by the Table List Startup POS, you use a POS data table to select what information to show for the dining table list. The source table is the Dining Table Status table. This POS data table is assigned to the grid control #HOSP-TABLELIST-GRID.

Required Field 

The Dining Table No. field (no. 3) is required in this POS data table. The Key Value Field 1 should be 3 and the field should not be shown in the list (keep it at the bottom and let Table Columns for the data table not include this field).

Optional Fields

Optional fields show the caption of the table, status, general information and alert text

Before version 26., it was necessary to use source expressions in this POS data table instead of fields from the Dining Table Status table. These source expressions slow down grid loading considerably.

Starting from version 26., if the POS data table does not include source expressions, an optimized process is used to populate the grid, resulting in much faster loading times.

POS Data Table with Source Expressions causing slow grid performance

The POS data table for the dining table list, can be using up to five source expressions. These source expressions slow down grid loading considerably.

Column Caption Source Expression (no field number)
Caption HO-TRCAP
Status HO-TRSTAT

Info

HO-TRINFO
Alert Text HO-TRALERT
Alert Mark HO-TRALERMA

 

POS Data Table with fields from the source table improving performance

To improve performance it is necessary to use fields from the Dining Table Status table directly instead of source expressions. These fields show the same information as the corresponding source expressions for the POS data table:

Column Caption Field No. Field Name
Caption 120 Caption Text
Status 126 Table Status Text

Info

102 Button Guest Text
Alert Text 111 Pop-up Alert Text
Alert Mark 125 Active Alert

Note: The POS data table also needs to be marked as Temporary.